Appendix B: Database Configuration

Reports that you wish to view through your web browser need to have their data source(s) configured as System DSNs (Data Source Name). When installed under Windows NT the Crystal Web Report Server is installed as a service and acquires the rights of the account it was assigned to run under to use User Profile Resources.

The web server administrator will need to create system DSNs using the ODBC Administrator in order to access data.

For Example:
1 Click Start and select Control Panel from the Settings menu.
2 Double-click ODBC Administrator.
3 Select the System DSN tab and click Add.
4 Select Microsoft Access Driver (.MDB) from the list and click Finish. The ODBC Microsoft Access Setup dialog box appears.
5 In the Data Source Name field type "Xtreme" and under Description type "Sample Database for Crystal Reports."
6 Under the Database heading click Select, then select the following directory:

C:\Program Files\Seagate Software\Crystal Reports

The XTREME.MDB file is visible in the left-hand list under Database Name.

7 Click OK.

Once you have completed the configuration, you should perform a test by attempting to view a report with your web browser.

For example, to test your database configuration under MS IIS, complete the following steps:

1 Start Microsoft Windows Explorer and create a new folder in the following directory:

C:\InetPub\wwwroot named reports

2 Start the IIS Service Manager by clicking Start, selecting Programs, and then selecting Internet Service Manager from the Microsoft Internet Server (Common) menu.
3 Highlight the www service, and select Service Properties from the Properties menu.
4 Select Directories tab, make sure the Directory Browsing Allowed option is selected, and click Add.
5 Click Browse and select the following directory:

C:\InetPub\wwwroot\reports

6 Locate the Virtual Directory field and type "/reports" for the alias.
7 Under Access, make sure Read and Execute are both selected.
8 Click Apply.
9 Click OK.

To open the report from a web browser, complete the following:

1 Open the Crystal Reports designer and select Custom SQL/ODBC and pick the System DSN just created from the list.
2 Save the report to the virtual directory where your Web server will be able to access it.
3 Open your web browser and enter the following URL to the reports directory:

http://<domain>/reports

Where <domain> is the domain name of your web server. An example of a domain name is: www.seagatesoftware.com

The name of the report you copied appears as a hyperlink on the resulting HTML page. Click the hyperlink. Your report appears in a Crystal Smart Viewer. Most current browsers will display reports using the ActiveX or Java-based viewers. If your browser does not support ActiveX or Java but does support frames, your report will appear in the HTML Frames viewer. If your browser does not support any of these formats, the report will appear in the HTML Page Viewer.

Note If you cannot view the report in the web browser after completing these steps, please refer to Appendix C: Web Server Configuration.

For the latest information about this product, please visit the web site at www.seagatesoftware.com/crystalreports.

Copyright ⌐ 1998 Seagate Software Inc. All rights reserved. Click here for additional information.